SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047493 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047493 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941273,58103,260521,789204,584402,1025204,918427,1012570,397013,318674,25472,117594,400156,964378,228276,899463,628128,270860,608321,505458,60186,843292,698268,27619,965011,436077,842570,767147,1026258,758920,209473,480799,922835,760408,248862,295906,188561,968276,623056,586153,509861,912008,872042,727141,70502,366827,85117,654906,278894,1045190,422144,34144,953597,200895,254135,741217,271053,35808,256641,510382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]