SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308428 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308428 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406649,351107,559859,508081,305128,464669,76237,592359,837259,243816,676825,270928,347562,424607,190495,887106,867923,641004,512204,529275,503189,226807,787506,310276,677832,426964,288907,997097,981323,580518,39207,857561,314923,818448,564436,984035,15367,126729,455792,218460,323969,776504,459061,400452,1031698,946721,182769,8409,15512,288790,341154,284385,164716,937738,238254,875840,66094,519548,35158,770473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001691s ]