SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505871 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505871 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229939,702629,630917,313685,134214,394213,859234,443819,870737,658034,530074,417893,562398,1018019,985549,605719,506033,324719,122618,90894,20970,1043126,734081,567360,842503,174238,275167,191358,454743,708916,200549,721413,609058,790182,584998,276606,820659,767332,555040,704484,824121,574396,227520,455430,355650,98727,910744,517615,544763,138163,975683,408899,661679,43363,140764,591958,707266,218347,674078,49171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]