SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 246570 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 246570 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150418,199875,911161,323584,484469,993436,537393,449657,186972,1005297,333403,234348,993645,768509,701714,1043236,122222,890495,231217,1013192,486682,562120,882298,37666,97095,313939,505385,888251,770144,541655,203554,300957,756145,726648,12318,824822,301985,334326,327710,678901,1030944,658701,313880,849257,702212,52175,691580,897141,457392,441945,937938,278831,588957,258425,429009,818855,5147,30723,496990,382947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 246570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 246570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]