SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501403 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501403 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684876,637863,463961,109139,104285,224427,135602,347607,927250,93823,220577,89733,654977,994525,471009,773243,1037834,58885,229994,364487,232732,1030544,218859,822461,234037,729189,680941,844645,96028,518256,279694,24529,635809,534028,358569,710735,766032,973693,508360,891354,901171,785406,460894,966058,864781,950813,977977,94596,898441,864073,805640,462822,45096,376881,659394,707140,26099,832972,756660,294138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]