SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515660 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515660 [ RunTime:0.004600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189611,54011,542533,667291,920991,1026543,698436,973389,388075,173950,106446,500347,847763,935140,124936,795323,870141,1941,626069,159223,666351,457676,1021232,314607,757360,1016234,675578,206333,629978,167298,273061,736453,221144,27601,16502,833983,450349,956221,930829,71360,928136,110617,655650,349710,269702,357264,177106,560807,105285,977774,583371,636340,1010407,795021,714729,831067,5728,362494,486582,596975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]