SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464856 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464856 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681397,648563,801249,89247,832069,204823,217607,685238,162497,182803,326231,203149,436022,512195,545326,564665,291003,956122,836794,661570,245115,904813,680572,554951,15010,325296,724531,505985,82718,896721,1043773,35711,85185,252715,134878,412798,301312,275886,47950,294920,102990,663838,52104,916684,606718,692599,856970,1028825,683757,311538,55260,1022505,480859,12319,1047504,185501,982730,682266,600543,890088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]