SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416030 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416030 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481386,104952,672831,835619,594716,1030310,400875,120684,793172,899273,689108,943822,269685,1039915,1006436,898563,274411,654301,458337,203136,301338,233297,507619,407515,785452,701452,313033,584068,439852,1029377,437622,811962,919405,970254,378795,23871,715438,750484,1020876,422561,707732,705719,432614,581958,427585,483267,573296,391916,580700,634852,920539,540600,970731,471677,628371,139934,491398,70234,311756,972641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]