SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292880 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292880 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272280,848501,508937,826128,798814,383236,136424,51758,191398,791601,147699,746396,333490,91140,408613,933479,325582,205628,91685,47176,700242,836556,781109,667388,401074,62955,627155,87287,427576,156577,894245,535727,1040933,150836,609401,624008,367512,886797,111974,249350,1020446,625071,366923,647195,861184,388963,217655,957280,1017780,38396,948782,516004,1793,604630,679796,965996,376318,668192,306677,178733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]