SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460674 LIMIT 1 [ RunTime:0.005406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460674 [ RunTime:0.008222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545542,860080,484180,522512,480528,974587,1035057,179627,859962,438560,896198,701138,950705,349219,310290,634677,520592,306532,676782,15647,830391,860231,690288,458834,75603,1014783,952862,284401,866373,1040725,274304,905659,339127,690388,226957,568502,38052,677164,1030410,1003702,977998,827080,500276,701711,186684,435795,136333,810240,23127,782953,883548,544691,676013,436210,454660,798568,409435,455090,66977,1011364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]