SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001964s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344404 LIMIT 1 [ RunTime:0.000611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344404 [ RunTime:0.004834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108868,295109,419227,185272,447574,1007158,280617,383105,691394,52264,487808,871351,663095,42903,815684,65039,545770,926545,169044,716572,318737,8236,301098,687392,612020,425840,897205,1041266,694864,633974,154728,4611,329204,328221,265603,13450,958387,761506,750484,466412,12244,472366,524336,215849,1004256,44770,657183,969783,390611,38204,737648,808499,864653,230606,733298,691068,438161,398701,375666,810422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]