SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040114 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040114 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955381,100741,620810,393565,774236,881846,332477,595808,656404,468287,527758,549374,961684,438451,838123,80007,783648,572365,528446,650877,796383,427967,1022568,963981,471881,812677,769914,68735,885799,172179,396836,893523,773314,384638,983589,492231,698943,105152,680158,500188,778010,614242,524726,317039,483319,946281,542373,577141,257356,616099,674986,50860,371180,413737,785692,698689,58416,101511,19225,214904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]