SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54549 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54549 [ RunTime:0.003250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778512,515888,82543,374727,582079,996477,219016,366179,710500,485075,100363,443874,805449,816913,375481,732518,81819,185093,984134,324384,190716,694634,392565,30897,1007378,945848,367021,169843,641977,715285,725174,354312,998374,727057,1007671,308477,415056,1018520,398891,791109,158980,328448,800445,620855,958939,482998,231989,1029828,686292,900189,389018,40158,447475,685794,17129,295275,63200,125353,167154,1990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54549 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54549 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003611s ]