SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025685 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025685 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110438,1042162,873615,405177,237894,647737,541996,769803,261836,245186,875451,8333,167432,891418,247678,904696,262700,600606,498712,48937,919875,636040,38277,31496,27467,380697,784488,334078,622115,368483,363912,1018756,20654,998675,960835,285813,691702,275299,54813,777238,645179,47045,360140,687214,181631,134687,692670,916971,530300,472362,94330,67179,1009013,916310,546053,699367,1043949,101012,232643,260685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001857s ]