SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104294 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104294 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2614,307332,109601,713195,772427,824908,720198,76516,566472,370689,294413,750389,514593,671235,897629,634001,313924,679122,971450,816915,74948,538235,24259,302733,67101,417613,246622,808371,346572,885912,149806,114982,132917,615454,710922,557560,793612,139989,928478,995921,883563,974323,897619,601311,218124,274492,235306,928026,498384,281347,49378,392969,366319,130930,259596,747070,385552,34557,645784,928627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]