SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301093 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301093 [ RunTime:0.002324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322954,642009,606099,292266,331741,958482,81403,691995,247729,369974,204595,1034834,138519,450412,540278,305412,923693,934554,745760,319211,46148,490023,614044,536675,835636,554488,56788,468494,775330,124053,85664,367839,836103,935669,213066,649647,18556,422711,1048293,567628,213778,882377,909217,250696,859515,169019,841265,497308,27785,189898,678342,281251,844750,513175,997741,958461,226265,489225,257575,241617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000367s ]