SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285212 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285212 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298848,1040670,272008,799324,922473,317875,904306,443942,485858,726120,108309,47338,163541,446330,328693,419460,790390,332657,608878,586700,979062,689351,661471,148077,921432,409283,788953,440005,497792,446154,174207,51077,57955,1004713,589239,192646,559475,830677,897200,1016286,409515,662654,649691,87907,91158,455330,549070,314164,447086,210109,920353,267851,415897,1226,404718,382311,344197,593044,99261,614860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]