SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539209 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539209 [ RunTime:0.004787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990629,830406,673643,897461,363573,184417,661191,349651,82329,837749,511764,635011,221672,961079,546165,503863,231152,321842,342670,858269,378405,861284,620626,815250,516869,735995,397961,177043,5708,484412,369926,939757,672386,13602,35451,105355,444835,546136,929333,69976,1032232,996149,1005158,934778,60211,582507,1001509,833051,706183,85062,894869,327721,1039767,897753,931392,797632,108691,711866,812023,27364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002287s ]