SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465245 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465245 [ RunTime:0.003631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017634,487946,794466,630161,279139,108966,429177,325122,91392,820557,966062,286755,881157,433859,62979,588132,639904,137310,595383,1039098,71148,467367,513426,922988,285201,724437,773433,139467,974821,836970,204511,655813,243735,735761,82196,401937,1013230,844173,802039,907548,578433,757412,273418,1047709,61909,1024688,620558,523687,774357,391281,834513,284357,554335,29411,701176,870608,137584,293334,1043004,805442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]