SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294806 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294806 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455470,294505,453235,9854,1017380,52878,314895,55844,673035,215254,536281,63718,673867,869050,172670,1028141,943101,305558,66426,315047,664034,59900,741004,779275,224594,760299,204403,803937,90357,256783,836656,9126,331934,667502,473160,61549,256814,653111,927874,1007887,430877,902946,858756,95875,334456,329841,299575,441943,536461,383568,1022739,151455,948545,265016,273724,231976,511236,1042908,16278,623432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]