SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543193 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543193 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456407,97828,210621,54893,651888,443793,108797,283305,613614,693580,246226,110028,34887,563064,1014695,631599,296865,732209,717791,1044509,816300,226440,302320,265042,71824,641871,120346,343208,93131,878919,1045111,708447,407038,310189,176624,480789,2232,244172,958677,955399,816880,798114,385124,1048715,31695,55729,826655,59307,394916,392230,342252,622897,806749,468203,1036800,719112,807678,206694,842718,114445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]