SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564271 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564271 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282785,902458,22474,14188,766495,420595,589651,676109,99086,907034,235402,851149,329244,185882,187884,176249,753772,445174,790822,641813,247918,608614,586746,427060,412469,560534,477715,546649,881769,166159,446843,702708,1033486,391388,408087,344890,715381,676336,770474,479315,19186,542545,295672,665692,472904,381687,122097,547640,412574,57800,598524,388595,849366,911447,153499,240100,49924,153223,870333,210922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001037s ]