SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382310 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382310 [ RunTime:0.003758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547869,603105,762270,945292,767322,809432,56190,352583,324016,765328,467294,903544,506714,978847,921267,234291,826540,266351,570121,986745,552509,254090,49319,992154,269657,122679,547579,470270,483631,71434,661016,709975,278991,997006,894736,457242,145063,1005314,60132,873281,32098,122604,949720,59233,342950,648147,440403,265416,165379,582020,146913,762689,1022839,75205,413554,932046,786622,83548,947415,6368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]