SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512481 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512481 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812610,215092,579859,590701,1012415,895679,140917,797447,285762,765578,285387,545204,822926,393750,1014205,246107,842189,13067,365360,694564,892240,638411,142798,720039,396048,655229,865295,504123,770302,979236,285183,689031,725217,819477,140687,51512,85406,742609,20872,684975,665,315657,647548,708591,134467,208572,368810,782224,70363,530742,424799,107956,525554,88621,687612,620161,609636,71666,877678,333088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]