SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801706 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801706 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895672,365857,47138,754953,125083,325849,811237,232836,25728,198951,657278,60050,198041,121755,416607,843007,554924,701246,541641,798928,950870,1045658,113525,718595,190155,971208,983241,177259,606086,426738,207569,729863,698836,97148,565581,528528,662236,315576,853728,386999,640634,586377,301709,540699,54817,752151,915800,844557,115708,1028448,937652,922573,204171,354380,846887,235950,267246,574761,94996,357217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]