SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548803 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548803 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281375,556380,137638,593395,572665,248426,888836,148066,438763,518282,854050,498715,916821,816945,311113,268372,494049,232138,656976,390406,153554,741105,1032169,408326,592333,718944,532905,971949,817990,780729,495251,211309,139733,1036259,869437,324321,326050,769952,582381,451974,404740,1010616,602050,710943,801337,253116,279644,924209,360362,984047,628937,919791,975824,83959,395993,1012179,461916,687788,168875,191161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]