SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562216 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562216 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302531,563932,213957,60786,612139,913181,379323,559494,440204,514850,614031,700229,448243,712711,879279,468704,958370,218985,445066,431233,186929,552651,416454,907367,435590,165369,691720,433898,206862,189271,218137,516441,648668,735008,462896,893522,20073,843439,728073,169488,309858,420015,77594,539068,921212,305193,198560,505583,509149,31529,391254,1018118,412764,630835,488652,961392,1030930,970845,552277,697920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]