SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419861 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419861 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997927,744552,54531,246179,973245,842034,947463,314423,704358,879692,767779,999249,133128,357348,796039,738333,451479,846308,29506,977077,851401,897624,918303,1033662,539542,721533,67311,961765,473459,304384,895614,836333,441877,235244,785670,853052,469056,72986,808740,687434,611055,233293,934176,718612,204475,521872,901962,316980,594377,221987,390903,418127,914671,161527,30724,145948,874206,521641,860044,862813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]