SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022380 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022380 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566354,942169,808936,546039,971854,688839,550390,907118,69540,184663,548609,88923,33490,940862,65231,734247,471080,166409,525160,906835,529096,954899,949163,523728,596251,533134,988425,686291,735592,491944,699560,565873,27849,386330,497111,359448,1044295,916264,349958,234196,749995,273503,914393,50888,618443,1014124,370090,807247,759466,558847,988268,462168,560682,918904,1041003,227079,242365,220807,211895,682326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002698s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]