SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281291 LIMIT 1 [ RunTime:0.001863s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281291 [ RunTime:0.002737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437173,184953,558852,868518,560778,569410,366488,587316,280051,862633,627830,489664,255556,296688,942583,1035460,977229,1003276,764706,914101,1018040,415779,845544,798245,27502,194102,763611,579588,314444,282151,959183,120827,745331,495315,313498,805427,144091,639818,295944,217032,128845,754774,149430,303680,1000400,352270,363805,145035,121213,756883,419947,1021452,769436,934511,578246,427213,186470,336640,1022585,589478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]