SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014961 LIMIT 1 [ RunTime:0.007249s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014961 [ RunTime:0.002497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042336,575996,754728,1011052,285199,992323,677221,373440,944897,735521,494610,509057,943005,9373,637828,1661,321528,893997,592119,155956,941821,739077,405082,756830,264561,173541,454717,933808,801407,266640,950190,378775,474078,537805,1037059,38384,232521,472492,165597,965153,1046644,815543,876651,1000426,728354,608819,181592,148417,440778,92839,4930,958502,468073,612225,89577,882887,484976,73872,112306,269235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000883s ]