SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001830s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514908 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514908 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939012,254585,417658,407017,231040,753538,589829,930734,554348,889990,294257,834860,213257,486809,877141,861303,981276,54841,450306,417737,204695,599625,933,896123,394241,977055,309724,225194,1044129,149111,120114,122341,723389,291063,643157,317776,330343,934828,185445,667456,550940,850466,577806,1007078,555140,747979,766983,284395,117446,137563,466259,198689,75439,1044846,677767,442564,274081,486381,962383,225401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]