SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402437 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402437 [ RunTime:0.003221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884817,864555,561418,928521,676549,285101,44519,1034912,374004,556942,156188,765269,603233,864885,961894,795512,635453,651331,627714,597827,249917,247835,471143,97389,813356,969331,569217,430663,52117,71145,83399,369029,140492,142521,160521,912572,660250,601709,1006657,5574,261382,128708,170028,334645,786919,810486,195816,444971,275012,537665,484662,317103,971463,1017461,476085,152124,6604,540429,182921,342925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]