SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297243 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297243 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248555,708231,482077,434703,693447,680121,201970,263870,984562,747982,246812,1043039,644231,410058,411748,215282,580217,239209,879411,969195,483027,129554,46019,326114,744592,677594,913172,528677,79342,209774,359311,422749,692746,196782,850649,799719,994333,510854,1012851,122172,769121,929335,550599,86930,106690,1019413,658806,970643,222164,288012,472234,851194,279704,839308,174464,162089,595163,573719,583147,196281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]