SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447655 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447655 [ RunTime:0.002476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2885,476064,873703,855118,1030971,506773,399349,995403,112383,405304,600411,414859,850879,886404,933517,168134,692087,860386,221115,322528,814952,886271,754194,792359,677813,805877,855139,1038538,153437,224319,155061,612632,608072,608299,546120,421396,765264,143259,696139,190929,373073,196332,553935,935383,279622,579237,317006,71298,1001274,458405,111407,862369,253988,195103,811860,495617,329465,405658,353784,390408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447655 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447655 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000946s ]