SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504882 LIMIT 1 [ RunTime:0.004728s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504882 [ RunTime:0.005123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885093,155406,583827,840228,958216,211605,58176,744956,437541,98506,643905,972189,436751,370686,179099,55693,636836,1012705,124561,867928,927906,914447,316357,408932,450487,153172,741286,219900,266827,908067,170698,369897,215613,305862,565052,891131,459804,518382,776895,269269,838937,599706,182408,337510,979801,387848,921910,710687,719925,1009419,290451,388299,398427,340739,702400,933186,1000800,747239,963794,257829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001482s ]