SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328097 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328097 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722003,68237,985368,1006751,937299,783536,385413,927802,102456,137261,1037147,23247,37620,155280,106920,423650,391828,3140,511818,1021638,221159,516765,415451,742370,602341,874265,828464,739083,726779,807608,235730,582305,32297,101529,839659,287981,191175,395202,411759,841782,927730,856273,123853,172669,177865,453612,625754,972165,580158,878582,96312,1040630,901051,361607,66631,532515,467461,682023,143103,1004374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]