SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544272 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544272 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481875,391791,629024,251531,871519,825289,107622,1035548,659003,871480,614305,1034764,228484,113477,627248,416712,506446,1032688,537421,1041982,525855,110480,365322,552000,855821,760608,965112,887386,233731,634370,1019502,474338,620414,224172,538932,288118,788195,151101,532182,753541,656626,961049,532434,1021558,389370,574561,182267,152214,357100,839431,58057,536925,841448,642323,627307,53297,822943,197134,966965,201172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]