SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499809 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499809 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193181,726278,677679,234312,222128,522759,781199,875758,70429,374484,252633,760380,531309,464121,737888,628718,492640,312259,835885,216626,705098,919322,1021002,811136,316788,255737,741555,886683,1035659,551251,939472,397639,675222,421626,891529,706462,97842,422525,608117,381959,998758,321657,653213,3729,726869,296913,893558,79628,554078,808819,767429,282403,645307,863220,955099,957920,852655,22680,488664,594001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]