SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 119046 LIMIT 1 [ RunTime:0.001058s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 119046 [ RunTime:0.004453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311631,618593,37727,995523,139083,905439,17130,146581,865501,36349,489971,307871,258593,94032,870030,366680,475075,407394,515899,1012397,970065,787480,685229,1002313,705660,202603,685139,768600,199610,217849,1047809,110778,180472,154067,500096,367040,702214,255259,123388,708508,230114,594701,126230,957654,293102,1032698,619902,724470,925852,182158,761963,574761,794472,403845,402333,997284,723902,34681,339315,547271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.029954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 119046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 119046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001782s ]