SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335178 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335178 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166025,646975,495020,192579,377829,195480,512404,552339,442681,50054,84706,966509,546806,1010774,976403,814154,214665,238006,967265,67713,382588,113759,9227,100141,420386,898808,357149,611193,591902,186231,367747,870893,870844,123090,20269,250402,129304,70420,285621,464725,687780,156118,917032,448073,926043,968712,9535,214420,372855,617391,475660,931887,10158,16168,598455,591485,658036,529870,439555,949544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]