SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121211 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121211 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251226,910914,680462,56988,841415,95061,776275,230986,874606,884314,159155,705888,689321,79050,184985,37788,291754,353795,355002,528679,1027210,167493,741724,191792,957368,538747,243287,298375,400508,123559,343771,270296,387581,887036,467907,490575,655840,58597,836092,1040214,51546,867813,473821,601281,1013536,183506,777870,163496,484427,145333,42868,998107,769713,959312,1003466,769053,905391,703380,946469,435613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]