SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364829 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364829 [ RunTime:0.006667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28153,867202,878322,753800,833,386664,123646,214360,759914,889998,690103,844623,540005,524370,183787,710027,295970,478189,923274,55980,385089,659499,584692,452027,809483,226983,596103,739419,47210,546332,487823,146494,911598,685799,21842,412259,527117,33518,709690,85616,73845,459634,8789,943913,317256,430648,901341,982005,983435,579254,978183,520477,609641,1035185,187312,1022944,159994,298779,49308,147289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]