SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400414 LIMIT 1 [ RunTime:0.000749s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400414 [ RunTime:0.002441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037346,83873,271349,177012,212621,465763,203466,1037462,38258,470485,875549,425182,97667,728775,342255,766319,498575,293918,631446,353946,202665,712529,292508,696958,1046966,1001616,965221,547386,1046559,139840,451949,579203,483069,891224,468475,1034963,203600,460236,23707,636169,647560,822815,721236,1047360,395426,369752,169054,90605,17526,438000,448389,757252,658120,1047040,1030836,46986,235749,266888,813840,716771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]