SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101917 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101917 [ RunTime:0.003341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997534,314591,210395,23978,859470,770216,171312,451660,971374,641808,104928,225110,856213,780842,86200,642172,779250,79183,58313,635176,278595,387639,267423,134108,490776,591611,35388,285449,699273,593704,115126,636513,542918,697980,798075,885427,667292,234581,175120,41684,112087,924641,271663,303106,981795,55859,349584,133236,1015802,587455,561442,961733,842579,972037,332778,458093,4078,133943,130518,494640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]