SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541858 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541858 [ RunTime:0.003559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029672,926857,863441,21688,301551,757145,109641,1035872,352534,352176,466516,663548,994075,132840,364970,363183,829906,74230,120542,41124,919399,954441,904678,909366,279523,165915,241268,514371,557829,935930,115534,491019,661766,297074,61586,710277,913586,1012544,444,863414,1001461,246560,764779,312816,506953,870267,236999,439897,307342,525156,347802,1019127,19922,657616,601797,405217,1036464,764899,664998,975021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]