SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567851 LIMIT 1 [ RunTime:0.004185s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567851 [ RunTime:0.001166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285473,603136,1006675,534640,468150,689674,381549,946142,599009,287155,77336,418870,247255,729188,479510,936148,338788,727329,806592,47148,686779,432435,539914,976066,825660,651010,541774,759133,371188,456755,570043,580906,138439,251839,683655,455663,590364,736447,580919,174181,444038,218078,325467,811618,758105,859705,950898,391342,486943,535488,657182,864324,977538,983850,376319,63439,879314,282806,690879,394306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]