SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 689613 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 689613 [ RunTime:0.002999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97496,235557,890741,267962,186743,412366,478721,374899,298268,952628,694957,296058,452273,173333,512503,515600,307494,961889,427852,45486,1014874,826844,865564,186887,118601,790576,821340,654494,368125,936524,653647,1037144,680015,147768,432217,884486,437623,342409,757503,87263,274169,501078,662656,665623,80332,612309,264068,188015,541908,481348,435380,205332,129402,306608,624490,376073,33204,776070,199162,116239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 689613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 689613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]