SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402954 LIMIT 1 [ RunTime:0.001692s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402954 [ RunTime:0.001377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820645,925361,153808,647284,815917,193077,172330,122829,38126,593166,657206,690485,177579,747470,476364,258585,193995,532255,187413,338075,436706,869582,696957,932613,608621,31719,951036,831425,481188,810363,40932,48859,844539,196421,536987,311415,1048916,358015,907118,652127,367162,660734,603857,925912,382288,184160,499892,577062,122999,827258,408604,434228,724333,555838,49522,947083,373603,516791,122596,244932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]