SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044802 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044802 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678992,89865,808579,799004,193084,566745,678962,645157,683668,32878,135983,11821,1036238,72842,262207,907120,645890,45196,721863,985183,644593,470866,642570,730658,463703,392532,119573,618288,17152,203561,853714,674026,114680,666866,142430,552009,201356,302624,990269,246354,485110,474001,149757,822802,196744,464152,609495,384364,563010,206814,894334,215828,916272,510351,275698,731997,173264,487948,111011,76865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]