SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502443 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502443 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336814,591304,500940,652575,34862,772355,928931,900436,363356,595800,261622,937305,380163,1035674,994938,129238,399491,294680,534909,62391,391839,813635,16150,91802,158893,318577,941455,266346,271487,678285,609781,174777,783276,726056,307652,457121,237064,690203,241393,159499,736382,725489,709965,500041,26877,980689,492216,502768,922064,10544,165185,648251,140349,158592,315191,828858,407016,267053,216001,819780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]