SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004903s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509685 LIMIT 1 [ RunTime:0.004174s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509685 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950012,1045444,864674,1046008,356330,807448,686606,483672,841105,181362,618776,1033603,104426,887356,286464,156830,100370,763679,789169,469252,870465,364004,621922,255714,671637,371049,808607,425459,400409,282519,633783,170420,498384,959196,454170,461775,861224,653256,738345,648276,42231,43376,134561,654299,886888,881685,357806,35210,39232,242311,10151,462105,744070,560740,173216,159930,1016878,82007,886364,122599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]