SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497185 LIMIT 1 [ RunTime:0.001052s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497185 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98938,957926,333414,392018,404041,567760,450114,96993,926821,393502,1003956,717271,755567,98767,432150,290120,609873,436057,263450,603014,444648,909990,843948,533973,1024850,52262,1026153,290518,426923,267391,492603,530990,521600,661406,134997,37383,142203,83705,474538,574586,92779,244622,854604,474135,571327,78190,29313,473900,598823,488020,929387,695448,649843,798318,677759,751017,386025,821393,514204,139625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]