SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682961 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682961 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407869,26285,816346,671918,753650,481726,876451,529220,361419,770186,356663,855671,89369,708705,119515,185084,1028756,546555,213761,573264,557022,566237,237990,959147,834155,749932,781919,69645,904812,565703,953291,1000819,119669,844488,152403,473543,709920,224852,952958,565753,226908,344211,886820,131524,1042757,84066,401885,524207,411749,600305,596550,180327,544500,560319,36917,250180,39038,295399,992266,385067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]