SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003013s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440181 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440181 [ RunTime:0.004926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023682,343328,839384,551867,707263,578282,254093,65147,282815,392931,714493,824647,608914,925655,383636,50218,879548,952329,950802,719373,241167,127566,286372,359790,903991,456568,1012254,408341,551100,874283,627267,157909,734916,288539,434193,952425,567988,439445,349461,185296,621110,837586,620393,145622,619069,653556,187126,891883,1036918,847666,27322,527784,490602,298608,814021,149079,369618,91044,632999,371605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]