SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414114 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414114 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035917,788403,240850,687994,1030398,821445,419848,83662,415209,108013,1042069,1013708,937331,193458,459863,968350,429055,700491,709552,80174,457014,191349,409118,489834,628555,968527,314519,339591,645410,476587,448119,111490,40483,466906,619120,543863,51568,282832,485589,438444,43966,445202,1006893,81188,82244,483128,199171,481264,441472,490716,190463,589404,577205,184402,204942,20200,463787,663602,372380,971711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]