SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507918 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507918 [ RunTime:0.002692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516994,34687,109888,784938,188679,213802,744789,932761,641439,99274,203687,107734,350158,562153,401664,530028,42068,228370,587638,586952,219011,300482,253388,841071,981000,378970,410342,181981,75945,492800,388214,353217,300766,619496,315417,262101,37565,56297,821092,434083,184605,405047,101438,672798,555220,785258,612994,49909,834258,788517,532136,1048410,678451,955038,13860,59129,343653,1018772,119395,493843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]