SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540058 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540058 [ RunTime:0.002569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553578,959097,217429,355603,394170,361930,1001449,17896,1041568,909645,99576,462812,826632,266038,141930,430077,523399,273392,390281,536597,43246,253612,584254,719229,633169,504813,685785,693672,607308,878107,152353,134815,643734,598408,569214,38410,935556,986155,967848,828111,340822,87590,814108,940731,800117,320083,424726,995959,1018623,236422,868021,460465,2852,71635,926712,692169,372929,552177,218174,814367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]