SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341848 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341848 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025029,454766,80769,937275,844744,1016338,767971,680912,195023,968868,319265,312002,246190,425870,171487,616620,232491,926294,530694,546929,557096,928516,666713,487681,838040,126894,167381,547031,674757,817193,843815,920168,890540,342405,945379,185338,477647,271120,4364,918490,250580,564439,589108,168144,337927,502973,598872,207938,417116,605297,544332,143770,686580,884478,517572,478667,892705,42250,947302,535487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]