SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017303 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017303 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138218,452684,522235,379975,653333,978023,397474,519432,888288,674488,401682,10254,300762,311338,981324,653091,980295,316795,97822,614999,683239,957284,826324,659102,93623,329091,208898,922504,1028109,255861,772335,420104,1986,222100,479470,90713,986187,497993,313361,100612,527068,89307,24771,671066,176624,961764,24934,85961,549048,466743,363139,367040,566595,25122,442653,408269,929560,33256,519542,5380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]