SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423313 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423313 [ RunTime:0.002662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930569,640695,216132,1011740,855472,775928,816808,576799,267199,1013397,982460,1045977,553873,378079,447235,117837,956257,182961,322600,206920,441148,930325,494671,290820,461445,417282,885460,731455,282603,541435,12895,51352,66261,482368,886390,52215,323442,680048,26161,262687,304128,599495,332088,733757,1045973,314931,795629,507476,978049,407234,205136,135721,75132,882437,25687,681904,397902,266643,706569,508940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]