SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488403 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488403 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409144,67453,870568,589115,142056,427457,856685,773598,551234,528589,731034,1042922,293615,93237,352265,2960,76309,1040906,391915,424668,464070,430352,759527,362864,916714,284916,936686,751788,346137,331324,375163,216978,754759,625199,950942,621049,870266,889437,95353,236867,692753,321468,196180,460095,924488,251195,7525,439552,157329,93706,467759,933866,973691,125376,546151,410798,87629,364236,192984,6744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]