SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144881 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144881 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296042,27608,12728,842311,403610,621233,984023,69470,127815,1017108,547414,247029,146191,959097,641540,1003859,606882,183549,425555,785389,124794,491988,446023,347044,340309,554856,524460,127726,774013,299664,1010804,360399,647897,184939,514943,405540,299254,888652,712543,992395,961246,164179,138689,642721,770440,87308,908057,172146,656492,368498,14991,109249,394290,731650,1028428,250627,516650,82451,181240,725929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]