SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023262 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023262 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69698,85004,987880,376619,377450,114030,335482,950707,53214,65039,775730,63430,718666,921464,243125,494525,740352,168401,146594,862886,650279,1030736,425652,620288,678386,279897,687581,948055,286681,307701,185932,521158,154258,225622,515355,540218,281436,757178,142351,939667,900655,169712,989091,174096,430774,1038191,621600,109252,290225,1006620,779756,572492,514985,315285,735180,975511,882639,737085,740631,328163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]