SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427951 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427951 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557442,196975,30040,877895,454012,19533,819969,680729,189457,991638,190738,383782,871476,712984,69370,7176,485879,858185,316530,555168,637026,28014,752743,320710,234464,328300,504928,88120,20198,699622,233901,846842,169424,564628,649519,927564,464858,99751,260923,730202,401048,737286,184093,233863,1022381,828281,519730,496137,231682,173878,28449,546169,204818,653672,66205,477207,243774,238261,446735,274803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]