SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807254 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807254 [ RunTime:0.002723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348189,976333,691410,868355,374710,315804,194330,288786,157876,486947,779115,5748,994922,625360,924073,356177,467135,840496,930736,573373,409056,881512,1002670,276000,601543,658530,280453,398094,289801,648369,480630,198127,157456,1018018,337368,1040066,756977,446119,410343,948406,656070,644256,464540,181266,131102,634311,262047,485676,55881,1016800,1037443,786308,142765,150792,701627,452039,124720,329780,820575,717362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]