SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401206 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401206 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647795,498404,79341,822072,705906,248350,805082,646789,24342,876974,832152,787761,469529,715645,651684,8148,234826,956621,58970,190538,855120,473211,554970,575475,692424,423700,670931,84318,198689,495643,421032,1034130,56372,434675,1017012,734506,485926,849935,222539,80477,985953,862053,960301,470326,399563,1005618,791310,769079,72997,434649,930860,472313,779730,507576,650860,646639,796261,319167,779771,488459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]