SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037029 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037029 [ RunTime:0.004342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18189,325164,679941,1037941,742211,940418,197043,534319,855701,809276,800847,159468,63619,882650,713409,977973,279541,594490,86663,348230,837751,752767,145738,29750,1042821,864217,164436,972765,293136,557520,424577,4056,225192,60459,321540,593050,260196,429764,797899,980760,77575,994495,700297,473106,533050,243911,402895,366574,785244,428249,329665,41281,957900,87204,201515,432214,770274,105196,835118,309002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]